/*
MySQL Backup
Database: springjdbc
Backup Time: 2021-09-13 10:49:58
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `springjdbc`.`a_file`;
DROP TABLE IF EXISTS `springjdbc`.`a_role`;
DROP TABLE IF EXISTS `springjdbc`.`a_user`;
DROP TABLE IF EXISTS `springjdbc`.`a_user_role`;
DROP TABLE IF EXISTS `springjdbc`.`anime`;
DROP TABLE IF EXISTS `springjdbc`.`animekiara`;
DROP TABLE IF EXISTS `springjdbc`.`animetype`;
DROP TABLE IF EXISTS `springjdbc`.`t_account`;
DROP TABLE IF EXISTS `springjdbc`.`t_book`;
CREATE TABLE `a_file` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `fileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `filePath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `a_role` (
  `id` varchar(255) DEFAULT NULL,
  `roleName` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `a_user` (
  `userId` int NOT NULL,
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`userId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `a_user_role` (
  `id` varchar(255) NOT NULL,
  `userId` varchar(255) DEFAULT NULL,
  `roleId` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `anime` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `typeId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `protoAuthor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `jianjie` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `animekiara` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `fromWhere` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `imgurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `animetype` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `typeName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `t_account` (
  `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `money` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `t_book` (
  `bookId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `bookname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `bkstatus` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`bookId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
BEGIN;
LOCK TABLES `springjdbc`.`a_file` WRITE;
DELETE FROM `springjdbc`.`a_file`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`a_role` WRITE;
DELETE FROM `springjdbc`.`a_role`;
INSERT INTO `springjdbc`.`a_role` (`id`,`roleName`) VALUES ('1', '超级管理员'),('11', '角色查询权限'),('12', '角色修改权限'),('13', '角色添加权限'),('14', '角色删除权限'),('2', '角色管理员'),('21', '动画查询权限'),('22', '动画修改权限'),('23', '动画添加权限'),('24', '动画删除权限'),('3', '动画管理员');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`a_user` WRITE;
DELETE FROM `springjdbc`.`a_user`;
INSERT INTO `springjdbc`.`a_user` (`userId`,`account`,`password`,`username`) VALUES (1, 'admin', '123456', '管理员'),(2, 'luke', '', '卢克'),(3, 'rumin', '123', '露明'),(4, '雪松啊', '123456', '雪松啊');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`a_user_role` WRITE;
DELETE FROM `springjdbc`.`a_user_role`;
INSERT INTO `springjdbc`.`a_user_role` (`id`,`userId`,`roleId`) VALUES ('1', '1', '1'),('2', '4', '11'),('3', '4', '21'),('4', '3', '2'),('5', '2', '3');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`anime` WRITE;
DELETE FROM `springjdbc`.`anime`;
INSERT INTO `springjdbc`.`anime` (`id`,`title`,`typeId`,`protoAuthor`,`jianjie`) VALUES ('1', 'RE：从零开始的异世界生活', '1', '长月达平', '讲述一个到便利店买零食的小哥菜月昴突然莫名其妙穿越到异世界的卖水果的大爷前而发生的故事'),('16301347', '骚动时节的少男少女', '3', '冈田磨里', '冈妈出品，必属精品'),('16301403', '骚动时节的少男少女4', '3', '冈田磨里', '冈妈出品，必属精品'),('16301404', '机动战士高达：铁血的格里芬尔斯', '13', '冈田磨里', '冈妈出品，必属精品'),('1630398319', '魔法少女小圆', '9', '虚渊玄', '爱的战士'),('2', '我的青春恋爱物语果然有问题', '5', '渡航', '大老师和雪乃的打情骂俏日常');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`animekiara` WRITE;
DELETE FROM `springjdbc`.`animekiara`;
INSERT INTO `springjdbc`.`animekiara` (`id`,`name`,`sex`,`fromWhere`,`score`,`url`,`imgurl`) VALUES (1, '爱尔奎特', '女', '真月谭月姬', '8.1', 'https://www.bilibili.com/bangumi/play/ss1983/?from=search&seid=10513684100857026390', 'http://47.106.124.209:8080/AnimeKiaRa/file/f26520cd5a884deab91fb9eccdd8d2e4.jpg'),(2, '阿尔托莉雅', '女', 'fate/zero', '100', 'https://www.bilibili.com/bangumi/play/ss1983/?from=search&seid=10513684100857026390', 'http://47.106.124.209:8080/AnimeKiaRa/file/495143cee149416f802ea6bc8564070b.webp'),(3, 'KERORO', '雄', 'KERORO军曹', '9.8', 'https://www.bilibili.com/bangumi/play/ss103/?from=search&seid=15445735361882919255', 'http://47.106.124.209:8080/AnimeKiaRa/file/28e0a47e82584d148b61e91bc6d6c28e.webp'),(4, '哆啦A梦', '男', '哆啦A梦', '100.0', 'https://www.dora-family.com/Resource:TV', 'http://47.106.124.209:8080/AnimeKiaRa/file/bd7b87a5ee0b4967ab295fa59746be60.jfif'),(6, '香风智乃', '女', '请问您今天要来点兔子吗？', '9.9', 'https://www.bilibili.com/bangumi/play/ss191/?from=search&seid=2614876005532383693', 'http://47.106.124.209:8080/AnimeKiaRa/file/437d84f08aac4a859c8de581f1ac944c.jpg'),(7, '黑桐干也', '男', '空之境界', '9.9', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/32af870d5fd842169bab00b1bc06944f.jpg'),(8, '桐谷和人', '男', '刀剑神域', '4.3', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/a6786f08c07a45969ab8acfdafc80d7e.jpg'),(9, '绯村剑心', '男', '浪客剑心', '9.9', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/f5b416fe5cda4852afde756cdc3d576a.jpg'),(10, '李舜生', '男', '黑之契约者', '9.9', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/34560d19087a43fabe0b517826792464.jpg'),(11, '三笠阿克曼', '女', '进击的巨人', '谏山创窝鈤尼咸忍', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/9b1bab4e0b3645be880033df4174c614.jpg'),(12, '春海和人', '难', '狗与剪刀的正确用法', '9.9', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/dc9297456503414c838991f1e95dd7d5.jpg'),(13, '加藤惠', '女', '路人女主的养成方法', '9.8', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/398d94e4a05d44e5b2e88460ff49bc30.jpg'),(14, '樱井孝宏', '男', '阿松', '9.8', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/9fbc4b41a1794434be1ea9fa5c0c7d58.png'),(15, '蓝猫', '男', '蓝猫淘气3000问', '9.8', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/b4a95c59f5ac4a62bc3237248af90e01.png'),(16, '陆小果', '男', '果冻三剑客', '9.8', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/2cf044820b004c2794c01d3c5554b4f1.jpg'),(999, '两仪末娜哒哟', '女', '空之境界未来福音', '9.8', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/0fe0def1c9d741ff91ab6ad718e86738.jpg'),(176359, '天野远子', '女', '文学少女', '9.0', '自己百度去', 'http://47.106.124.209:8080/AnimeKiaRa/file/a148783854914c478244485d4aae17d1.jpg'),(200159, '假面骑士decade', '男', '假面骑士decade', '9.8', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/fcbc169954c64b95a7abf708e52be578.png'),(200192, '富坚勇太', '男', '中二病也要谈恋爱', '9.8', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/d27a3b1c7dc5437d818086c624ee2040.jpg'),(16300362, '高町奈叶', '女', '魔法少女奈叶', '9.9', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/28b6a277b2c94fdb9f8f12cc1dd306a9.png'),(16300365, '小鸟游六花', '女', '中二病也要谈恋爱', '9.9', 'www.baidu.com', 'http://47.106.124.209:8080/AnimeKiaRa/file/0f2629479336412da44d74e1d12cb86f.jpg'),(16314260, '戏水', '男', '三次元世界', '10', '三次元自己找', 'http://47.106.124.209:8080/AnimeKiaRa/file/8147629e684c49dea8e1292150aa7e2d.png');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`animetype` WRITE;
DELETE FROM `springjdbc`.`animetype`;
INSERT INTO `springjdbc`.`animetype` (`id`,`typeName`) VALUES ('1', '异世界'),('10', '日常'),('11', '音乐'),('12', '运动'),('13', '机甲'),('2', '时空穿越'),('3', '少女'),('4', '热血'),('5', '恋爱'),('6', '搞笑'),('7', '校园'),('8', '科幻'),('9', '魔幻');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`t_account` WRITE;
DELETE FROM `springjdbc`.`t_account`;
INSERT INTO `springjdbc`.`t_account` (`id`,`username`,`money`) VALUES ('1', 'lucy', 900),('2', 'mary', 1000);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `springjdbc`.`t_book` WRITE;
DELETE FROM `springjdbc`.`t_book`;
INSERT INTO `springjdbc`.`t_book` (`bookId`,`bookname`,`bkstatus`) VALUES ('1000', '从百草园到三味书屋', '1'),('1001', '狂人日记', '0'),('1002', '呐喊', '1'),('2001', '食灵零', '0'),('2020', '神在的星期一', '3'),('2222', '神不在的星期天', '2'),('3', 'java2', '3001'),('4000', '伞兵0号', '0'),('4001', '伞兵1号', '1'),('40010', '伞兵10号', '10'),('40011', '伞兵11号', '11'),('40012', '伞兵12号', '12'),('40013', '伞兵13号', '13'),('40014', '伞兵14号', '14'),('40015', '伞兵15号', '15'),('40016', '伞兵16号', '16'),('40017', '伞兵17号', '17'),('40018', '伞兵18号', '18'),('40019', '伞兵19号', '19'),('4002', '伞兵2号', '2'),('40020', '伞兵20号', '20'),('40021', '伞兵21号', '21'),('40022', '伞兵22号', '22'),('40023', '伞兵23号', '23'),('40024', '伞兵24号', '24'),('40025', '伞兵25号', '25'),('40026', '伞兵26号', '26'),('40027', '伞兵27号', '27'),('40028', '伞兵28号', '28'),('40029', '伞兵29号', '29'),('4003', '伞兵3号', '3'),('40030', '伞兵30号', '30'),('40031', '伞兵31号', '31'),('40032', '伞兵32号', '32'),('40033', '伞兵33号', '33'),('40034', '伞兵34号', '34'),('40035', '伞兵35号', '35'),('40036', '伞兵36号', '36'),('40037', '伞兵37号', '37'),('40038', '伞兵38号', '38'),('40039', '伞兵39号', '39'),('4004', '伞兵4号', '4'),('40040', '伞兵40号', '40'),('40041', '伞兵41号', '41'),('40042', '伞兵42号', '42'),('40043', '伞兵43号', '43'),('40044', '伞兵44号', '44'),('40045', '伞兵45号', '45'),('40046', '伞兵46号', '46'),('40047', '伞兵47号', '47'),('40048', '伞兵48号', '48'),('40049', '伞兵49号', '49'),('4005', '伞兵5号', '5'),('4006', '伞兵6号', '6'),('4007', '伞兵7号', '7'),('4008', '伞兵8号', '8'),('4009', '伞兵9号', '9');
UNLOCK TABLES;
COMMIT;
